AdRegistrationGroupTerm 
Logical Entity Name  AdRegistrationGroupTerm 
Default Table Name  AdRegistrationGroupTerm 
Physical Only  NO 
Definition 
 
Note 
 

AdRegistrationGroupTerm Columns 
ColumnName  Domain  Datatype  NULL  Definition 
AdRegistrationGroupTermID(PK)    int  NO 
 
AdRegistrationGroupID(FK)    int  NO 
 
AdTermID(FK)    int  NO 
 
AdvisementSyGroupsID(FK)    int  YES 
 
InternalRegistrationBeginDateTime    datetime  NO 
 
InternalRegistrationEndDateTime    datetime  NO 
 
OnLineRegistrationBeginDateTime    datetime  NO 
 
OnLineRegistrationEndDateTime    datetime  NO 
 
GroupPriority    smallint  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID(FK)    int  NO 
 
Ts    timestamp  NO 
 
SyCampusID(FK)    int  YES 
 

AdRegistrationGroupTerm Primary and Unique Keys 
Key Name  Key Type  Keys 
AdRegistrationGroupTerm_AdRegistrationGroupTerm_AdvisemenSyGroupsID_AdRegistrationGroupterm_U_N_IDX  Index  AdvisementSyGroupsID, AdRegistrationGroupTermID 
AdRegistrationGroupTerm_AdRegistrationGroupID_AdTermID_SyCampusID_U_N_IDX  Index  AdRegistrationGroupID, AdTermID, SyCampusID 
AdRegistrationGroupTerm_AdRegistrationGroupTermID_U_C_IDX  PrimaryKey  AdRegistrationGroupTermID 

AdRegistrationGroupTerm Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdRegistrationGroup  Non-Identifying  One To Zero or More  FK_AdRegistrationGroupTerm_AdRegistrationGroupID_AdRegistrationGroup_AdRegistrationGroupID      AdRegistrationGroupID  NO  YES 
AdTerm  Non-Identifying  One To Zero or More  FK_AdRegistrationGroupTerm_AdTermID_AdTerm_AdTermID      AdTermID  NO  YES 
SyGroups  Non-Identifying  Zero or One to Zero or More  FK_AdRegistrationGroupTerm_AdvisementSyGroupsID_SyGroups_SyGroupsID      AdvisementSyGroupsID  NO  YES 
SyCampus  Non-Identifying  Zero or One to Zero or More  FK_AdRegistrationGroupTerm_SyCampusId_SyCampus_SyCampusId      SyCampusID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_AdRegistrationGroupTerm_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

AdRegistrationGroupTerm Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_AdRegistrationGroupTerm_OnLineDates  ([OnLineRegistrationEndDateTime] is null or [OnLineRegistrationBeginDateTime] is null or [OnLineRegistrationEndDateTime] > [OnLineRegistrationBeginDateTime]) 
Chk_AdRegistrationGroupTerm_InternalDates  ([InternalRegistrationEndDateTime] is null or [InternalRegistrationBeginDateTime] is null or [InternalRegistrationEndDateTime] > [InternalRegistrationBeginDateTime])